Employment Equity: An Analysis of Distribution of Salary Ranges of Public Service of Canada Employees
Brittny Vongdara & Catalina Albury
9/26/2022
The Data
Here, disproportionality index is used as a measure of equitable
representation. It is calculated as below.
\[\frac{\%_{Group\: X; \:salary\: range \:
i}}{\% _{All \:Employees; \:salary\: range \: i}} = DI _{Group\:X;
\:salary\:range\:i}\]
For example, 23.51% of Black employees and 16.70% of all employees are are within the <60K salary range. This gives us a DI of 1.41.
\[ DI_{Black \: employees; <60K } =\frac{23.51\%}{16.70\%} = 1.41\]
Below are the values used to create the figures. This data is based on self identification of equity-deserving groups, and represents pre-tax salary ranges excluding bonuses and promotions, publically availble here. It was collected in March of 2021. Please note that this data was not imputed for suppressed numbers. For more information and the scripts used to produce this analysis, visit the project’s GitHub repository.
| All Employees | Black Employees | All Visible Minority Employees | Non-Visible Minority Employees | Indigenous Employees | Employees with Disabilities | ||||||
Salary Range | Percent | DI | Percent | DI | Percent | DI | Percent | DI | Percent | DI | Percent | DI |
Less than $60,000 | 16.70 | 1 | 23.53 | 1.41 | 17.70 | 1.06 | 16.47 | 0.99 | 17.91 | 1.07 | 18.54 | 1.11 |
$60,000 to $69,999 | 17.56 | 1 | 23.86 | 1.36 | 19.67 | 1.12 | 17.06 | 0.97 | 18.61 | 1.06 | 19.31 | 1.10 |
$70,000 to $84,999 | 23.14 | 1 | 20.94 | 0.90 | 22.07 | 0.95 | 23.39 | 1.01 | 24.46 | 1.06 | 21.07 | 0.91 |
$85,000 to $99,999 | 19.30 | 1 | 15.72 | 0.81 | 18.68 | 0.97 | 19.45 | 1.01 | 21.97 | 1.14 | 19.19 | 0.99 |
Over $100,000K | 23.30 | 1 | 15.72 | 0.67 | 21.69 | 0.93 | 23.67 | 1.02 | 17.05 | 0.73 | 21.90 | 0.94 |
All ranges | 100.00 | 1 | 100.00 | 1.00 | 100.00 | 1.00 | 100.00 | 1.00 | 100.00 | 1.00 | 100.00 | 1.00 |
Plot 1: DI of all groups by salary range
The dotted line represents equitable representation. It can been seen that Black employees are overrepresented at the lower salary ranges and underrepresented at higher ranges compared to the other groups. As can be seen by the “All Non-Minority Employees” bars, an equal DI across all salary ranges should be expected.
English
Français
Plot 3: A direct comparison of DI in Black Employees vs. Non-Visible Minority Employees
This plot zooms in on our “baseline” group and compares it to the Black employee group, which appears to be the most affected by inequity. A steady decrease in representation with each increase in salary range is clearly visible for the Black employee group.
English
Français
